Installation Note 50686: The execution of the native DB2 DDL generates "unexpected token" messages
 |  |  |  |  |
In SAS® Detail Data Store for Insurance, creation of physical tables using the native DB2 DDL (d2ddl.dll) might fail and generate the following messages:
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0104N An unexpected token "CREATE TABLE ACCOUNTING_TRANS ( ACCO" was
found following "ne Insurance DDS */ ". Expected tokens may include:
"". SQLSTATE=42601
SQL0104N An unexpected token "CREATE TABLE ACCOUNTING_TRANS (
ACCO" was found following "ne Insurance DDS */
". Expected tokens may include: "".
This problem occurs because of formatting errors in the DDL. As a workaround, you can create the DB2 physical tables by using the %D2DDL SAS macro. For more information, see the SAS Detail Data Store for Insurance Administrator's Guide.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Detail Data Store for Insurance | Microsoft® Windows® for x64 | 5.5 | 5.7 | 9.4 TS1M2 | |
| Microsoft Windows 8 Enterprise 32-bit | 5.5 | 5.7 | 9.4 TS1M2 | |||
| Microsoft Windows 8 Enterprise x64 | 5.5 | 5.7 | 9.4 TS1M2 | |||
| Microsoft Windows 8 Pro 32-bit | 5.5 | 5.7 | 9.4 TS1M2 | |||
| Microsoft Windows 8 Pro x64 | 5.5 | 5.7 | 9.4 TS1M2 | |||
| Microsoft Windows Server 2008 | 5.5 | 5.7 | 9.4 TS1M2 | |||
| Microsoft Windows Server 2008 R2 | 5.5 | 5.7 | 9.4 TS1M2 | |||
| Microsoft Windows Server 2008 for x64 | 5.5 | 5.7 | 9.4 TS1M2 | |||
| Microsoft Windows Server 2012 Datacenter | 5.5 | 5.7 | 9.4 TS1M2 | |||
| Microsoft Windows Server 2012 Std | 5.5 | 5.7 | 9.4 TS1M2 | |||
| Windows 7 Enterprise 32 bit | 5.5 | 5.7 | 9.4 TS1M2 | |||
| Windows 7 Enterprise x64 | 5.5 | 5.7 | 9.4 TS1M2 | |||
| Windows 7 Home Premium 32 bit | 5.5 | 5.7 | 9.4 TS1M2 | |||
| Windows 7 Home Premium x64 | 5.5 | 5.7 | 9.4 TS1M2 | |||
| Windows 7 Professional 32 bit | 5.5 | 5.7 | 9.4 TS1M2 | |||
| Windows 7 Professional x64 | 5.5 | 5.7 | 9.4 TS1M2 | |||
| Windows 7 Ultimate 32 bit | 5.5 | 5.7 | 9.4 TS1M2 | |||
| Windows 7 Ultimate x64 | 5.5 | 5.7 | 9.4 TS1M2 | |||
| 64-bit Enabled AIX | 5.5 | 5.7 | 9.4 TS1M2 | |||
| 64-bit Enabled HP-UX | 5.5 | 5.7 | 9.4 TS1M2 | |||
| 64-bit Enabled Solaris | 5.5 | 5.7 | 9.4 TS1M2 | |||
| HP-UX IPF | 5.5 | 5.7 | 9.4 TS1M2 | |||
| Linux | 5.5 | 5.7 | 9.4 TS1M2 | |||
| Linux for x64 | 5.5 | 5.7 | 9.4 TS1M2 | |||
| Solaris for x64 | 5.5 | 5.7 | 9.4 TS1M2 | |||
A fix for this issue for SAS Risk Management for Insurance 2.12 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/K02.html#50686A fix for this issue for SAS Risk Dimensions Server Component 5.5 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/K60.html#50686| Type: | Installation Note |
| Priority: | medium |
| Date Modified: | 2013-08-23 06:55:52 |
| Date Created: | 2013-08-08 08:38:21 |